pp108 : Querying by Having Clause

Querying by Having Clause
This topic describes the procedure to build query using Having clause.

Before you begin this task:
The Having clause is used in conjunction with the Group by clause.


  1. Select the Having text box to add the Having clause to the query.
  2. Select the required attribute from the Attributes list and double-click it.
    Note: You can add any kind of expressions to the Having text box by double-clicking the Expression list.


    Attention*When *Having clause is used, the fields present in Having text box should also be present in Group by expression.